Advantages of DBMS

There are following advantages of DBMS

1. Reduction in Data Redundancy The duplication of data refers to data redundancy. DBMS cannot make separate copies of the same data. All the data is kept at a place and different applications refer to data from centrally controlled system.

Data redundancy occurs when the same piece of data exists in multiple places, whereas data inconsistency is when the same data exists in different formats in multiple tables. Unfortunately, data redundancy can cause data inconsistency, which can provide a company with unreliable and/or meaningless information.

2. Better Interaction with Users In DBMS, the availability of up to - date information improves the data to be access or respond as per user requests.

3. Improvement in Data Security DBMS can allow the means of access to the database through the authorised channels. To ensure security, DBMS provides security tools, i.e. username and password.

4. Maintenance of Data Integrity Data integrity ensures that the data of database is accurate In DBMS, data is centralized and used by many users at a time, it is essential to enforce integrity controls.

5. Ease of Application Development The application programmer needs to develop the application programs according to the user's need. The other issues like concurrent access, security, data integrity, etc. are handled by database itself. This makes the application development an easier task.

6. Backup and Recovery The DBMS provides backup and recovery subsystem that is responsible to recover data from hardware and software failures.

In the Question:

In which, the database can be restored up to the last consistent state after the system failure ?

The Answer is Recovery. There are three basic types of recovery: instance recovery, crash recovery, and media recovery.

Hence the Option B is Correct.

Advantages of DBMS

There are following advantages of DBMS

1. Reduction in Data Redundancy The duplication of data refers to data redundancy. DBMS cannot make separate copies of the same data. All the data is kept at a place and different applications refer to data from centrally controlled system.

Data redundancy occurs when the same piece of data exists in multiple places, whereas data inconsistency is when the same data exists in different formats in multiple tables. Unfortunately, data redundancy can cause data inconsistency, which can provide a company with unreliable and/or meaningless information.

2. Better Interaction with Users In DBMS, the availability of up to - date information improves the data to be access or respond as per user requests.

3. Improvement in Data Security DBMS can allow the means of access to the database through the authorised channels. To ensure security, DBMS provides security tools, i.e. username and password.

4. Maintenance of Data Integrity Data integrity ensures that the data of database is accurate In DBMS, data is centralized and used by many users at a time, it is essential to enforce integrity controls.

5. Ease of Application Development The application programmer needs to develop the application programs according to the user's need. The other issues like concurrent access, security, data integrity, etc. are handled by database itself. This makes the application development an easier task.

6. Backup and Recovery The DBMS provides backup and recovery subsystem that is responsible to recover data from hardware and software failures.

In the Question:

______ means that the data contained in a database is accurate and reliable.

The Answer is Data integrity.It is maintained by a collection of processes, rules, and standards implemented during the design phase.

Hence the Option B is Correct.

Advantages of DBMS

There are following advantages of DBMS

1. Reduction in Data Redundancy The duplication of data refers to data redundancy. DBMS cannot make separate copies of the same data. All the data is kept at a place and different applications refer to data from centrally controlled system.

Data redundancy occurs when the same piece of data exists in multiple places, whereas data inconsistency is when the same data exists in different formats in multiple tables. Unfortunately, data redundancy can cause data inconsistency, which can provide a company with unreliable and/or meaningless information.

2. Better Interaction with Users In DBMS, the availability of up to - date information improves the data to be access or respond as per user requests.

3. Improvement in Data Security DBMS can allow the means of access to the database through the authorised channels. To ensure security, DBMS provides security tools, i.e. username and password.

4. Maintenance of Data Integrity Data integrity ensures that the data of database is accurate In DBMS, data is centralized and used by many users at a time, it is essential to enforce integrity controls.

5. Ease of Application Development The application programmer needs to develop the application programs according to the user's need. The other issues like concurrent access, security, data integrity, etc. are handled by database itself. This makes the application development an easier task.

6. Backup and Recovery The DBMS provides backup and recovery subsystem that is responsible to recover data from hardware and software failures.

In the Question:

When data changes in multiple lists and all lists are not updated. This causes _______________

The answer is Data inconsistency. A DBMS can reduce data redundancy and inconsistency by minimizing isolated files in which the same data are repeated.

Hence the Option D is Correct.